<cfquery name = "qcomments" datasource="#request.dsn#">
SELECT * FROM blog_comments JOIN contacts_users ON contacts_users.id = blog_comments.userid
WHERE bid = <cfqueryparam value="#bid#" cfsqltype="cf_sql_varchar">
</cfquery>